METARweatherSite

Entity Definition

Logical Name : METARweatherSite
Physical Name : LU_METAR_WTHR_STE

METAR is a format for reporting weather information. A METAR weather report is predominantly used by pilots in fulfillment of a part of a pre-flight weather briefing, and by meteorologists, who use aggregated METAR information to assist in weather forecasting. Raw METAR is the most popular format in the world for the transmission of weather data. It is highly standardized through International Civil Aviation Organization (ICAO), which allows it to be understood throughout most of the world. In ARTS we use METAR as a world wide basis for establishing weather reporting areas. METARs typically come from airports or permanent weather observation stations. Reports are generated once an hour, but if conditions change significantly, a report known as a special (SPECI) may be issued. Some METARs are encoded by automated airport weather stations located at airports, military bases, and other sites. Some locations still use augmented observations, which are recorded by digital sensors, encoded via software, and then reviewed by certified weather observers or forecasters prior to being transmitted. Observations may also be taken by trained observers or forecasters who manually observe and encode their observations prior to transmission.

Data Definition

Attribute	Description	Physical Name	Domain	Data Type	Foreign Key Table
ICAOcode (PK)	International code used to designate airport/weather reporting stations. This is the closest thing to an international standard for designating weather forecasting/current condition reporting areas. It's value for ARTS is that it is an international standard ICAO = International Civil Aviation Organization	CD_ICAO	Code4External	char(4)
StationName	METAR station name (16 char provided fomr METAR)	NM_STN	Name	varchar(40)
ISOCountryCode (FK)	The ISO-3166-1 two letter code denoting a locality in which the retailer does business.	CD_CY_ISO	Code2	char(2)	ISO3166-1Country(LO_CY_ISO)
GeophysicalLocationCoordinateID (FK)	Token identifier for a POINT location (a longitude, latitude, altitude coordinate).	ID_GEO_LCN_CRDN	Identity	integer	GeophysicalLocationCoordinate(LO_CRDN_GEO_LCN)

Relationships

Parent Entity	Verb Phrase	Child Entity
GeophysicalLocationCoordinate	defines location for	METARweatherSite
ISO3166-1Country	is country of	METARweatherSite
METARweatherSite	is origin of	METARWeatherForecast
METARweatherSite	is origin of	METARWeatherCondition
METARweatherSite	is weather reporting location for	Site

Logical Views containing METARweatherSite

Logical View
Logical 10102 - EnterpriseWeather